Recent Questions

In the table below, I want to sum all of New York ACT in Q2 after the sales have been multiplied by the corresponding rates. Is there a one-shot formula I can use without needing to multiply all the items of the first table with the corresponding rates, then summing? The result I'm looking for would be (49*.45)+(10*.37)=25.45.

Recent Questions...

I have a spreadsheet with multiple tables (they're not actually formatted as tables but as charts) that are listed one after another. I would like each table to alteate in color. I would also like it to be set so that if I add or remove an entire chart the coloring scheme updates automatically. I'm attempting to use conditional formatting but I can't get it to alteate for every table. I thought if I merge the table to act as one cell that would work but I can't get it to do that. Any thoughts?

Recent Questions...

While using a word processor I prefer to user the keyboard almost exclusively, but when pasting text in MS Word I seem forced to use the mouse. I can find no way to specify how to treat formatting (keep source / match destination / text only) on a one-off basis without using the mouse (distracting and slow) or altering my default settings (even worse).

Is there a way to do this? It seems to me I need either a keyboard shortcut to enter the Paste Options dialogue after pasting or a different command that I can use to specify the formatting option. I looked at Paste Special, but that only seems to provide one relevant option, namely plain text.

I am using MS Word 2007, but an answer applying to other versions would obviously be more generally useful.

Recent Questions...

I'm looking for a way to sync bookmarks across 3 browsers: Chrome, Firefox, and IE. I'm not crazy about web-based options like XMarks, and I'm determined to figure out a free way to achieve this. I need to devise a system that syncs automatically (periodically at least) and that doesn't depend on 3rd party servers.

Ideas?

Recent Questions...

I have windows 10 on C: drive and I installed ubuntu 14.04 on D: on the 30.51 GB partition and Ubuntu 16.04 on 7.92GB partition.

But both my ubuntu are always crashing and I want to delete and install again. The problem is that now I cant delete both partitions because they only show the "help" option.

How the hell do I delete this? I have no idea. They say they are primary partitions.

Recent Questions...

I work for a Granite Company so every time a new slab comes in I have to take a picture of it, give it the proper name and then upload it to Facebook and our website. On the website I select all the files for that album, upload, and all the file names automatically populate the description field. Not so for Facebook though, is there a program or something i can use to do that on Facebook?

Recent Questions...

I have a client for which I'm developing an app. That app must connect to their server, which sits behind a NetScaler load balancer configured with TLS1.2 only and requires client certificate authentication.

When I tried to connect to that server through the NetScaler, I get the error "The underlying connection was closed: An unexpected error occurred on a send." I am doing this from a C# console app where I have set ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12. However, if I use TLS1.1 then it is able to connect.

If I try setting IE to use TLS1.2 explicitly, it also cannot connect to the site. If I set it to use TLS1.1, then the site loads fine.

Now here's the strange part: from Firefox, with TLS1.2 explicitly set, the site loads normally. I cannot for the life of me figure out why Firefox is the only way to authenticate against the NetScaler with a client certificate and TLS1.2.

BTW I tried from multiple machines in different geographic locations and had the same results each time. Here is a WireShark dump I captured of the handshake in IE and in Firefox. The only difference I found is that FF adds a field called "Certificate Verify" but not sure if that is why it works in FF but not IE.

IN FIREFOX:

IN IE:

So can anyone share a little insight as to why this might be failing? What can I do differently in my code/configuration in order to support this?

Recent Questions...

A co-worker tried to connect a windows 10 laptop to an exteal monitor. The monitor was never picked up in the first place and he right clicked on the home screen, went to graphics output and set it to "monitor". After doing so the laptop screen is now black, and obviously its not showing on the monitor either.

Is there a way to revert the graphics settings with a hotkey or something? If I reboot in safe mode, will it use original settings? How do I force reboot windows 10 into safe mode without having access to the start screen?

Recent Questions...

I need to display on the dashboard the following details every month need some idea on how to plot the data and use the best fit chart for this data Data to report - Number of EAP and EDG requests received Number of these requests pending and Average tu around time for these requests to be processed.

I've used this formula to calculate the tu around time for each request processed example 3 requests rec'd date is 5/1/2016 and processed date is 5/10/16 so tu around time equals 9 days any help you could provide will be appreciated [email protected]

Recent Questions...

I want to host my Node.js application in LAN (for testers). What I'm trying to is setting up the Windows task in Task Scheduler.

My task needs to run npm start and node server.js commands to work as two separate processes (1st runs up the microservice that is hosting my static HTML, JS content; and the 2nd is running the Express.js API server.

When I start my task manually it works fine. But the problem is I want it to start automatically after the server was restarted (on startup event).

What happens? - It is actually starting correctly, no errors in history. The processes are working (after I log in), but the page is not reachable (ERR_CONNECTION_TIMED_OUT). I have to stop it and start again manually to make it work.

Here's my task's configuration:

<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.4" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
  <RegistrationInfo>
    <Date>2016-05-19T13:59:25.5552942</Date>
    <Author>BSGauthor</Author>
  </RegistrationInfo>
  <Triggers>
    <BootTrigger>
      <Enabled>true</Enabled>
      <Delay>PT5M</Delay>
    </BootTrigger>
    <CalendarTrigger>
      <Repetition>
        <Interval>PT30M</Interval>
        <Duration>P1D</Duration>
        <StopAtDurationEnd>true</StopAtDurationEnd>
      </Repetition>
      <StartBoundary>2016-05-19T13:59:34.7184867</StartBoundary>
      <ExecutionTimeLimit>PT1H</ExecutionTimeLimit>
      <Enabled>true</Enabled>
      <ScheduleByDay>
        <DaysInterval>1</DaysInterval>
      </ScheduleByDay>
    </CalendarTrigger>
  </Triggers>
  <Principals>
    <Principal id="Author">
      <UserId>S-1-5-18</UserId>
      <RunLevel>HighestAvailable</RunLevel>
    </Principal>
  </Principals>
  <Settings>
    <MultipleInstancesPolicy>StopExisting</MultipleInstancesPolicy>
    <DisallowStartIfOnBatteries>false</DisallowStartIfOnBatteries>
    <StopIfGoingOnBatteries>false</StopIfGoingOnBatteries>
    <AllowHardTerminate>false</AllowHardTerminate>
    <StartWhenAvailable>false</StartWhenAvailable>
    <RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
    <IdleSettings>
      <StopOnIdleEnd>true</StopOnIdleEnd>
      <RestartOnIdle>false</RestartOnIdle>
    </IdleSettings>
    <AllowStartOnDemand>true</AllowStartOnDemand>
    <Enabled>true</Enabled>
    <Hidden>false</Hidden>
    <RunOnlyIfIdle>false</RunOnlyIfIdle>
    <DisallowStartOnRemoteAppSession>false</DisallowStartOnRemoteAppSession>
    <UseUnifiedSchedulingEngine>false</UseUnifiedSchedulingEngine>
    <WakeToRun>false</WakeToRun>
    <ExecutionTimeLimit>PT0S</ExecutionTimeLimit>
    <Priority>7</Priority>
    <RestartOnFailure>
      <Interval>PT5M</Interval>
      <Count>10</Count>
    </RestartOnFailure>
  </Settings>
  <Actions Context="Author">
    <Exec>
      <Command>node</Command>
      <Arguments>server.js</Arguments>
      <WorkingDirectory>C:SomeProjectapi</WorkingDirectory>
    </Exec>
    <Exec>
      <Command>npm</Command>
      <Arguments>start</Arguments>
      <WorkingDirectory>C:SomeProjectweb</WorkingDirectory>
    </Exec>
  </Actions>
</Task>

Recent Questions...